package cn.wolfcode.mapper;

import cn.wolfcode.domain.Dept;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface DeptMapper {
    @Select("""
     select id, name, create_time, update_time from dept
    """)
    List<Dept> list();
    @Delete("""
            delete from dept where id=#{id}
    """)
    void delete(Long id);
    @Insert("""
                            insert into dept (name, create_time, update_time) 
                            values (#{name},now(), now())
    """)
    void save(Dept dept);
    @Select("""
     select id, name, create_time, update_time from dept where id = #{id}
    """)
    Dept getById(Long id);
    @Update("""
            update dept
            set name=#{name},
                update_time=now()
            where  id=#{id}
            """)
    void update(Dept dept);
    @Select("""
                    select * from dept
                    where name=#{name}
    """)
    Dept selByDeptName(String name);
}
